In addition to 2D or 3D view modes, you can view attribute data for features in table format.
After completing this lesson, you’ll be able to:
Sven continues to work on his Excel to geodatabase workspace using FME Workbench (2022.0 or later) and inspects the Vancouver.gdb output by right-clicking on the Vancouver [FILEGDB] writer in the Navigator and selecting View Written Data…. This will show BusinessOwners and PublicArt in Visual Preview. If Sven had selected View Written Data on a writer feature type, only that feature type would be displayed in Visual Preview.
The Table view now displays BusinessOwners.
After running the translation, the bottom-right corner of the Table view shows the number of rows (100). This number matches the feature count on the feature connection line on the canvas. Sven uses this count to confirm that all his features have been written. He sees that 100 features were read and confirms that 100 exist in the written data.
The Table view shows an extra attribute: OBJECTID. Additional attributes may be created by the writer if they are required by the format, as in this case. All Esri geodatabase datasets contain an OBJECTID attribute. An ObjectID is a unique, not null integer field used to uniquely identify rows in tables in a geodatabase.
Sven checks that all the desired columns (feature attributes) are present and have values. Sven notices that the entries for Last_Name and License_Number are all <null>. This is typically a bad sign; null means that there is no value for that attribute. On the canvas, Sven clicks on the triangle on the BusinessOwners writer feature type to see the feature type’s attributes. The triangles are red beside the attributes with null values. The red triangles indicate that the attribute is not mapped to a source attribute. This occurred because the spaces in Last Name and License Number were converted to underscores. The spaces were converted to underscores because the Esri geodatabase format does not support spaces in attribute names.
Vancouver.gdb also contains the PublicArt feature class. Sven clicks on the drop-down triangle beside BusinessOwners and changes the table to display data for PublicArt.
Sven notices that PublicArt is not sorted alphabetically by name. He clicks on the Name heading to sort the column alphabetically. This is also a good way to find any <null> attribute values. Null attributes will appear first.
Sven’s colleagues are really interested in birds and he is curious if there is any bird-related public art. He enters "bird" in the filter at the foot of the Table view. The Table view then only displays the three features that have "bird" in an attribute value.
Make sure you have followed along with Sven’s steps.